<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN">
<html>
<head>
<title>public</title>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    <meta name="generator" content="Doc-O-Matic" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <link rel="STYLESHEET" href="default.css" type="text/css" />

<script type="text/javascript" src="scripts.js"></script>
</head>
<body class="Element700" onload="onBodyLoadEx('frames.html', 'topic', '!!MEMBERVISIBLITY_public_TSelectSqlStatement.html');" onmousedown="onBodyMouseDown();">

<!-- Begin Popups -->

<!-- End Popups -->

<!-- Begin Page Header -->
<div class="Element710" id="areafixed">
<div class="Element94">
<em>You are here:</em> Symbol Reference &gt; <a href="!!CLASSES.html" target="topic">Classes</a> &gt; <a href="Common_SQL_Statement_Classes.html" target="topic">Common SQL Statement Classes</a> &gt; <a href="TSelectSqlStatement.html" target="topic">TSelectSqlStatement Class</a> &gt; <a href="!!MEMBERVISIBLITY_public_TSelectSqlStatement.html" target="topic">public</a></div>
<div class="Element92">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td width="50%">
<div class="Element2">
<a href="contents.html" target="tocidx"><img src="btn_globals_contents_midblue.gif" border="0" alt="Contents" title="Contents" onmouseover="switchImage(this, 'btn_globals_contents_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_contents_midblue.gif');"></a><a href="idx.html" target="tocidx"><img src="btn_globals_index_midblue.gif" border="0" alt="Index" title="Index" onmouseover="switchImage(this, 'btn_globals_index_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_index_midblue.gif');"></a><a href="index.html" target="topic"><img src="btn_globals_home_midblue.gif" border="0" alt="Home" title="Home" onmouseover="switchImage(this, 'btn_globals_home_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_home_midblue.gif');"></a></div>
</td><td width="50%">
<div class="Element90">
<a href="TSelectSqlStatement.html" target="topic"><img src="btn_prev_midblue.gif" border="0" alt="Previous" title="Previous" onmouseover="switchImage(this, 'btn_prev_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_prev_midblue.gif');"></a><a href="TSelectSqlStatement.html" target="topic"><img src="btn_up_midblue.gif" border="0" alt="Up" title="Up" onmouseover="switchImage(this, 'btn_up_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_up_midblue.gif');"></a><a href="TSelectSqlStatement_SelectSetType.html" target="topic"><img src="btn_next_midblue.gif" border="0" alt="Next" title="Next" onmouseover="switchImage(this, 'btn_next_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_next_midblue.gif');"></a></div>
</td></tr></table><div class="Element5">
public</div>
</div>
</div>

<!-- End Page Header -->

<!-- Begin Client Area -->
<div class="Element720" id="areascroll">
<div class="Element721">

<!-- Begin Page Content -->
<div class="Element58">
<a name="Summary"></a><div class="Element11">
<div class="Element10">
<p class="Element10">
The public members of the TSelectSqlStatement class are listed here.</p></div>
</div>
<a name="Fields"></a><div class="Section1000030">
Fields</div>
<div class="Element10030">
<div class="Section30">
<div class="Element212">
<div class="TableDiv">
<table cellspacing="0" class="Table0">
<tr>
<td class="Element200" valign="top" width="35%">
<div class="Element201">
Field&nbsp;</div></td><td class="Element204" valign="top" width="65%">
<div class="Element205">
Description&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TSelectSqlStatement_SelectSetType.html" target="topic">SelectSetType</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>If this sql statement uses set operators to manipulate the result sets of two or more queries, this property stands for the type of set operator.&nbsp;</div></td></tr></table></div></div>
</div>
</div>
<a name="Properties"></a><div class="Section1000030">
Properties</div>
<div class="Element10030">
<div class="Section30">
<div class="Element212">
<div class="TableDiv">
<table cellspacing="0" class="Table0">
<tr>
<td class="Element200" valign="top" width="35%">
<div class="Element201">
Property&nbsp;</div></td><td class="Element204" valign="top" width="65%">
<div class="Element205">
Description&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TSelectSqlStatement_JoinTables.html" target="topic">JoinTables</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
Joins in from clause. Join is represented by class <a href="TLzJoin.html" target="topic">TLzJoin</a>.<br><br>Usually, Join count in from is 1.<br><br>/* ANSI join */<br>SELECT emp_lname, emp_fname, job_title<br>FROM employee<br>JOIN jobs ON employee.job_id = jobs.job_id;<br><br>But in the &quot;old&quot; way to do join operations,Theta joins, which use the WHERE clause to establish the filtering criteria, join count is the number of table in from clause.<br><br>/* Theta join */<br>SELECT emp_lname, emp_fname, job_title<br>FROM employee, jobs<br>WHERE employee.job_id = jobs. job_id;<br><br>Join count in this from clause is 2.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TSelectSqlStatement_LeftStmt.html" target="topic">LeftStmt</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>If this sql statement uses set operators to manipulate the result sets of two or more queries, then LeftStmt is the left side of this select sql. LeftStmt may includes set operators recursively.<br><br>It's type of <a href="TSelectSqlStatement.html" target="topic">TSelectSqlStatement</a>&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TSelectSqlStatement_RightStmt.html" target="topic">RightStmt</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>If this sql statement uses set operators to manipulate the result sets of two or more queries, then RightStmt is the right side of this select sql. RightStmt don't includes set operators.<br><br>It's type of <a href="TSelectSqlStatement.html" target="topic">TSelectSqlStatement</a>&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TSelectSqlStatement_ValueClause.html" target="topic">ValueClause</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Value clause of DB2.<br>&nbsp;</div></td></tr></table></div></div>
</div>
</div>
</div>
<!-- End Page Content -->

<!-- Begin Page Footer -->
<div class="Element93">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td width="100%">
<div class="Element3">
Gudu software http://www.sqlparser.com</div>
</td></tr><tr><td width="100%">
<div class="Element97">
Send <a href="#" onclick="sendFeedback('info@sqlparser.com', 'Documentation Feedback', 'Project: General SQL Parser Help file%0ATopic ID: !!MEMBERVISIBLITY_public_TSelectSqlStatement%0ATitle: public');">comments</a> about this topic.</div>
</td></tr></table></div>

<!-- End Page Footer -->
</div>
</div>

<!-- End Client Area -->
</body></html>